Data Profiling

Dataset statistics

Number of variables	13
Number of observations	8369
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	850.1 KiB
Average record size in memory	104.0 B

Variable types

Numeric	8
Categorical	2
Text	3

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`rooms` is highly overall correlated with `garages` and 2 other fields	High correlation
`garages` is highly overall correlated with `rooms` and 2 other fields	High correlation
`useful_area` is highly overall correlated with `rooms` and 2 other fields	High correlation
`value` is highly overall correlated with `rooms` and 2 other fields	High correlation

Reproduction

Analysis started	2023-08-07 19:13:44.147981
Analysis finished	2023-08-07 19:13:56.179302
Duration	12.03 seconds
Software version	ydata-profiling vv4.4.0
Download configuration	config.json

rooms
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8392878

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.89592517
Coefficient of variation (CV)	0.31554573
Kurtosis	-0.33134813
Mean	2.8392878
Median Absolute Deviation (MAD)	1
Skewness	-0.24796203
Sum	23762
Variance	0.8026819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
3	3579	42.8%
2	2112	25.2%
4	1983	23.7%
1	654	7.8%
5	34	0.4%
6	5	0.1%
7	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	654	7.8%
2	2112	25.2%
3	3579	42.8%
4	1983	23.7%
5	34	0.4%
6	5	0.1%
7	1	< 0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
8	1	< 0.1%
7	1	< 0.1%
6	5	0.1%
5	34	0.4%
4	1983	23.7%
3	3579	42.8%
2	2112	25.2%
1	654	7.8%

garages
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0330983

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	12
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.121227
Coefficient of variation (CV)	0.55148687
Kurtosis	1.8712973
Mean	2.0330983
Median Absolute Deviation (MAD)	1
Skewness	1.1509314
Sum	17015
Variance	1.2571501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	3416	40.8%
2	2536	30.3%
3	1436	17.2%
4	771	9.2%
5	151	1.8%
6	47	0.6%
7	5	0.1%
8	4	< 0.1%
9	1	< 0.1%
12	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3416	40.8%
2	2536	30.3%
3	1436	17.2%
4	771	9.2%
5	151	1.8%
6	47	0.6%
7	5	0.1%
8	4	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
10	1	< 0.1%
9	1	< 0.1%
8	4	< 0.1%
7	5	0.1%
6	47	0.6%
5	151	1.8%
4	771	9.2%
3	1436	17.2%
2	2536	30.3%

useful_area
Real number (ℝ)

HIGH CORRELATION

Distinct	426
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	145.13825

Minimum	25
Maximum	826
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	25
5-th percentile	48
Q1	80
median	120
Q3	190
95-th percentile	320
Maximum	826
Range	801
Interquartile range (IQR)	110

Descriptive statistics

Standard deviation	88.90856
Coefficient of variation (CV)	0.61257842
Kurtosis	2.9981681
Mean	145.13825
Median Absolute Deviation (MAD)	50
Skewness	1.47175
Sum	1214662
Variance	7904.732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	160	1.9%
110	151	1.8%
120	144	1.7%
90	138	1.6%
100	136	1.6%
80	130	1.6%
140	117	1.4%
130	113	1.4%
75	108	1.3%
60	108	1.3%
Other values (416)	7064	84.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	1	< 0.1%
26	1	< 0.1%
27	2	< 0.1%
28	5	0.1%
29	3	< 0.1%
30	17	0.2%
31	6	0.1%
32	6	0.1%
33	12	0.1%
34	14	0.2%

Value	Count	Frequency (%)
826	1	< 0.1%
700	2	< 0.1%
692	1	< 0.1%
675	1	< 0.1%
660	1	< 0.1%
650	1	< 0.1%
640	1	< 0.1%
600	3	< 0.1%
550	4	< 0.1%
549	1	< 0.1%

latitude
Real number (ℝ)

Distinct	6266
Distinct (%)	74.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-23.578133

Minimum	-23.647398
Maximum	-23.491429
Zeros	0
Zeros (%)	0.0%
Negative	8369
Negative (%)	100.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	-23.647398
5-th percentile	-23.631059
Q1	-23.606055
median	-23.576006
Q3	-23.552001
95-th percentile	-23.529389
Maximum	-23.491429
Range	0.1559692
Interquartile range (IQR)	0.0540533

Descriptive statistics

Standard deviation	0.033658857
Coefficient of variation (CV)	-0.0014275454
Kurtosis	-0.78193656
Mean	-23.578133
Median Absolute Deviation (MAD)	0.0278532
Skewness	0.064543009
Sum	-197325.4
Variance	0.0011329186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-23.601446	26	0.3%
-23.6366667	22	0.3%
-23.6011079	21	0.3%
-23.5652892	15	0.2%
-23.5713184	15	0.2%
-23.6347054	11	0.1%
-23.5097595	11	0.1%
-23.6390494	11	0.1%
-23.6330678	10	0.1%
-23.5486537	10	0.1%
Other values (6256)	8217	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.6473981	1	< 0.1%
-23.6472832	1	< 0.1%
-23.6472723	2	< 0.1%
-23.6472437	1	< 0.1%
-23.6471752	2	< 0.1%
-23.6471218	1	< 0.1%
-23.6470599	2	< 0.1%
-23.6470516	1	< 0.1%
-23.6470464	1	< 0.1%
-23.6470444	1	< 0.1%

Value	Count	Frequency (%)
-23.4914289	1	< 0.1%
-23.4915289	1	< 0.1%
-23.4915443	1	< 0.1%
-23.4915744	1	< 0.1%
-23.491579	1	< 0.1%
-23.4916163	1	< 0.1%
-23.4916249	1	< 0.1%
-23.4916299	1	< 0.1%
-23.4916584	1	< 0.1%
-23.4917384	1	< 0.1%

longitude
Real number (ℝ)

Distinct	6272
Distinct (%)	74.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-46.666587

Minimum	-46.739607
Maximum	-46.567446
Zeros	0
Zeros (%)	0.0%
Negative	8369
Negative (%)	100.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	-46.739607
5-th percentile	-46.730893
Q1	-46.685372
median	-46.665436
Q3	-46.645129
95-th percentile	-46.607742
Maximum	-46.567446
Range	0.1721615
Interquartile range (IQR)	0.040243

Descriptive statistics

Standard deviation	0.034280021
Coefficient of variation (CV)	-0.00073457312
Kurtosis	0.14454882
Mean	-46.666587
Median Absolute Deviation (MAD)	0.020146
Skewness	0.043907939
Sum	-390552.67
Variance	0.0011751198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-46.717651	26	0.3%
-46.73	22	0.3%
-46.7161175	21	0.3%
-46.6349529	15	0.2%
-46.6630318	15	0.2%
-46.7007211	11	0.1%
-46.7146293	11	0.1%
-46.6507406	11	0.1%
-46.5953517	10	0.1%
-46.7276921	10	0.1%
Other values (6262)	8217	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-46.7396075	2	< 0.1%
-46.7395826	2	< 0.1%
-46.7395789	1	< 0.1%
-46.7395722	1	< 0.1%
-46.7395677	1	< 0.1%
-46.7395479	1	< 0.1%
-46.7395249	1	< 0.1%
-46.7394959	1	< 0.1%
-46.7394457	3	< 0.1%
-46.7394285	2	< 0.1%

Value	Count	Frequency (%)
-46.567446	1	< 0.1%
-46.5675586	1	< 0.1%
-46.5675631	3	< 0.1%
-46.5676633	1	< 0.1%
-46.5677867	1	< 0.1%
-46.5678154	1	< 0.1%
-46.567842	2	< 0.1%
-46.5678545	2	< 0.1%
-46.5678852	1	< 0.1%
-46.5679589	1	< 0.1%

value
Real number (ℝ)

HIGH CORRELATION

Distinct	7844
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1478880.6

Minimum	175101
Maximum	4999430
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	175101
5-th percentile	424585
Q1	731354
median	1161620
Q3	1960360
95-th percentile	3668298
Maximum	4999430
Range	4824329
Interquartile range (IQR)	1229006

Descriptive statistics

Standard deviation	1002856.1
Coefficient of variation (CV)	0.67811839
Kurtosis	1.202007
Mean	1478880.6
Median Absolute Deviation (MAD)	530438
Skewness	1.2891742
Sum	1.2376751 × 10¹⁰
Variance	1.0057204 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
297708	7	0.1%
1123800	6	0.1%
840479	5	0.1%
499316	5	0.1%
1093710	5	0.1%
624407	5	0.1%
832444	5	0.1%
1288730	4	< 0.1%
609607	4	< 0.1%
837118	4	< 0.1%
Other values (7834)	8319	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
175101	1	< 0.1%
191894	1	< 0.1%
192101	1	< 0.1%
194056	1	< 0.1%
196269	1	< 0.1%
196852	1	< 0.1%
211209	1	< 0.1%
219560	1	< 0.1%
220212	1	< 0.1%
221027	3	< 0.1%

Value	Count	Frequency (%)
4999430	1	< 0.1%
4999320	1	< 0.1%
4994770	1	< 0.1%
4990650	1	< 0.1%
4985270	1	< 0.1%
4983680	1	< 0.1%
4983190	1	< 0.1%
4977320	1	< 0.1%
4976850	1	< 0.1%
4965330	1	< 0.1%

interior_quality
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.5 KiB

1	2811
2	2786
3	2772

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	8369
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	3
3rd row	2
4th row	3
5th row	2

Common Values

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

Most occurring characters

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8369	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	8369	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8369	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2811	33.6%
2	2786	33.3%
3	2772	33.1%

time_on_market
Real number (ℝ)

Distinct	4788
Distinct (%)	57.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.66114

Minimum	0.097115531
Maximum	359.82024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	0.097115531
5-th percentile	6
Q1	34
median	88.030113
Q3	177.02297
95-th percentile	307.3791
Maximum	359.82024
Range	359.72313
Interquartile range (IQR)	143.02297

Descriptive statistics

Standard deviation	95.152735
Coefficient of variation (CV)	0.82986035
Kurtosis	-0.3857524
Mean	114.66114
Median Absolute Deviation (MAD)	62.595799
Skewness	0.80676853
Sum	959599.09
Variance	9054.043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	64	0.8%
2	54	0.6%
11	50	0.6%
13	48	0.6%
28	47	0.6%
7	47	0.6%
23	46	0.5%
5	45	0.5%
6	44	0.5%
4	43	0.5%
Other values (4778)	7881	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.09711553064	1	< 0.1%
0.142504697	1	< 0.1%
0.1432957567	1	< 0.1%
0.1760284416	1	< 0.1%
0.2374070195	1	< 0.1%
0.2410805883	1	< 0.1%
0.2618874258	1	< 0.1%
0.3049262501	1	< 0.1%
0.3848981899	1	< 0.1%
0.4402768998	1	< 0.1%

Value	Count	Frequency (%)
359.8202427	1	< 0.1%
359.8105072	1	< 0.1%
359.6643219	1	< 0.1%
359.6058738	1	< 0.1%
359.0785544	1	< 0.1%
358.8971827	1	< 0.1%
358.832001	1	< 0.1%
358.7832063	1	< 0.1%
358.5659347	1	< 0.1%
358.4602374	1	< 0.1%

sold
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	65.5 KiB

0	4484
1	3885

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	8369
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Most occurring characters

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8369	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	8369	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8369	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4484	53.6%
1	3885	46.4%

Unnamed: 0
Real number (ℝ)

Distinct	6292
Distinct (%)	75.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2834.0705

Minimum	0
Maximum	6291
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	65.5 KiB

Quantile statistics

Minimum	0
5-th percentile	233
Q1	1226
median	2677
Q3	4365
95-th percentile	5880.6
Maximum	6291
Range	6291
Interquartile range (IQR)	3139

Descriptive statistics

Standard deviation	1817.2521
Coefficient of variation (CV)	0.64121627
Kurtosis	-1.1630305
Mean	2834.0705
Median Absolute Deviation (MAD)	1546
Skewness	0.20549326
Sum	23718336
Variance	3302405.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
179	26	0.3%
283	22	0.3%
298	21	0.3%
1940	15	0.2%
369	15	0.2%
513	11	0.1%
1193	11	0.1%
1172	11	0.1%
2643	10	0.1%
395	10	0.1%
Other values (6282)	8217	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	2	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	3	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
6291	1	< 0.1%
6290	1	< 0.1%
6289	1	< 0.1%
6288	1	< 0.1%
6287	1	< 0.1%
6286	1	< 0.1%
6285	1	< 0.1%
6284	1	< 0.1%
6283	1	< 0.1%
6282	1	< 0.1%

endereço
Text

Distinct	6136
Distinct (%)	73.3%
Missing	0
Missing (%)	0.0%
Memory size	65.5 KiB

Length

Max length	140
Median length	120
Mean length	77.175768
Min length	55

Characters and Unicode

Total characters	645884
Distinct characters	95
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4689 ?
Unique (%)	56.0%

Sample

1st row	R. José de Oliveira Coelho, 200 - Vila Andrade, São Paulo - SP, 05727-240, Brazil
2nd row	R. Araquã, 70 - Bela Vista, São Paulo - SP, 01306-020, Brazil
3rd row	Rua Correia de Lemos, 327 - Vila da Saúde, São Paulo - SP, 04140-000, Brazil
4th row	R. Itapura, 129 - Vila Gomes Cardim, São Paulo - SP, 03310-000, Brazil
5th row	R. Garapeba, 255 - Jardim Vila Mariana, São Paulo - SP, 04116-210, Brazil

Value	Count	Frequency (%)
	18383	16.0%
são	8503	7.4%
paulo	8452	7.4%
sp	8369	7.3%
brazil	8369	7.3%
r	5568	4.8%
vila	2339	2.0%
de	1270	1.1%
edifício	1248	1.1%
rua	1203	1.0%
Other values (7006)	51212	44.6%

Most occurring characters

Value	Count	Frequency (%)
	106547	16.5%
a	48791	7.6%
o	38461	6.0%
,	33455	5.2%
i	31928	4.9%
0	31810	4.9%
l	27286	4.2%
-	26670	4.1%
r	23109	3.6%
P	20455	3.2%
Other values (85)	257372	39.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	293410	45.4%
Space Separator	106547	16.5%
Decimal Number	92487	14.3%
Uppercase Letter	85417	13.2%
Other Punctuation	41210	6.4%
Dash Punctuation	26671	4.1%
Open Punctuation	57	< 0.1%
Close Punctuation	55	< 0.1%
Other Letter	22	< 0.1%
Math Symbol	6	< 0.1%
Other values (2)	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	48791	16.6%
o	38461	13.1%
i	31928	10.9%
l	27286	9.3%
r	23109	7.9%
e	15893	5.4%
u	15573	5.3%
n	13459	4.6%
d	11352	3.9%
ã	9618	3.3%
Other values (28)	57940	19.7%

Uppercase Letter

Value	Count	Frequency (%)
P	20455	23.9%
S	18896	22.1%
B	10655	12.5%
R	7599	8.9%
C	5148	6.0%
A	4201	4.9%
V	3239	3.8%
M	2950	3.5%
J	1927	2.3%
E	1728	2.0%
Other values (20)	8619	10.1%

Decimal Number

Value	Count	Frequency (%)
0	31810	34.4%
1	13755	14.9%
4	9590	10.4%
5	8375	9.1%
2	7877	8.5%
3	6790	7.3%
6	4504	4.9%
7	3739	4.0%
8	3286	3.6%
9	2761	3.0%

Other Punctuation

Value	Count	Frequency (%)
,	33455	81.2%
.	7689	18.7%
'	34	0.1%
/	30	0.1%
:	2	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	26670	> 99.9%
–	1	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	56	98.2%
[	1	1.8%

Close Punctuation

Value	Count	Frequency (%)
)	54	98.2%
]	1	1.8%

Math Symbol

Value	Count	Frequency (%)
+	4	66.7%
\|	2	33.3%

Space Separator

Value	Count	Frequency (%)
	106547	100.0%

Other Letter

Value	Count	Frequency (%)
º	22	100.0%

Format

Value	Count	Frequency (%)
	1	100.0%

Other Symbol

Value	Count	Frequency (%)
°	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	378849	58.7%
Common	267035	41.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	48791	12.9%
o	38461	10.2%
i	31928	8.4%
l	27286	7.2%
r	23109	6.1%
P	20455	5.4%
S	18896	5.0%
e	15893	4.2%
u	15573	4.1%
n	13459	3.6%
Other values (59)	124998	33.0%

Common

Value	Count	Frequency (%)
	106547	39.9%
,	33455	12.5%
0	31810	11.9%
-	26670	10.0%
1	13755	5.2%
4	9590	3.6%
5	8375	3.1%
2	7877	2.9%
.	7689	2.9%
3	6790	2.5%
Other values (16)	14477	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	628769	97.4%
None	17114	2.6%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	106547	16.9%
a	48791	7.8%
o	38461	6.1%
,	33455	5.3%
i	31928	5.1%
0	31810	5.1%
l	27286	4.3%
-	26670	4.2%
r	23109	3.7%
P	20455	3.3%
Other values (65)	240257	38.2%

None

Value	Count	Frequency (%)
ã	9618	56.2%
í	3221	18.8%
é	855	5.0%
ó	850	5.0%
ç	760	4.4%
á	654	3.8%
ú	431	2.5%
ô	215	1.3%
ê	191	1.1%
õ	93	0.5%
Other values (9)	226	1.3%

Punctuation

Value	Count	Frequency (%)
–	1	100.0%

bairro
Text

Distinct	259
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	65.5 KiB

Length

Max length	32
Median length	28
Mean length	11.660772
Min length	2

Characters and Unicode

Total characters	97589
Distinct characters	78
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	0.8%

Sample

1st row	Vila Andrade
2nd row	Bela Vista
3rd row	Vila da Saúde
4th row	Vila Gomes Cardim
5th row	Jardim Vila Mariana

Value	Count	Frequency (%)
vila	2329	15.8%
jardim	863	5.8%
paulista	500	3.4%
mariana	476	3.2%
pinheiros	392	2.7%
perdizes	360	2.4%
da	349	2.4%
itaim	285	1.9%
indianópolis	284	1.9%
santa	283	1.9%
Other values (277)	8635	58.5%

Most occurring characters

Value	Count	Frequency (%)
a	14844	15.2%
i	10899	11.2%
	6387	6.5%
o	5954	6.1%
e	5847	6.0%
l	5755	5.9%
r	5442	5.6%
n	4824	4.9%
d	3581	3.7%
s	3297	3.4%
Other values (68)	30759	31.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	76796	78.7%
Uppercase Letter	14193	14.5%
Space Separator	6387	6.5%
Decimal Number	84	0.1%
Open Punctuation	54	0.1%
Close Punctuation	54	0.1%
Other Punctuation	17	< 0.1%
Dash Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14844	19.3%
i	10899	14.2%
o	5954	7.8%
e	5847	7.6%
l	5755	7.5%
r	5442	7.1%
n	4824	6.3%
d	3581	4.7%
s	3297	4.3%
m	2881	3.8%
Other values (25)	13472	17.5%

Uppercase Letter

Value	Count	Frequency (%)
V	2636	18.6%
P	2052	14.5%
C	1762	12.4%
M	1271	9.0%
B	1164	8.2%
S	1057	7.4%
J	953	6.7%
I	821	5.8%
A	771	5.4%
L	351	2.5%
Other values (15)	1355	9.5%

Decimal Number

Value	Count	Frequency (%)
0	16	19.0%
3	13	15.5%
1	12	14.3%
4	10	11.9%
7	8	9.5%
2	8	9.5%
6	8	9.5%
5	4	4.8%
8	3	3.6%
9	2	2.4%

Open Punctuation

Value	Count	Frequency (%)
(	53	98.1%
[	1	1.9%

Close Punctuation

Value	Count	Frequency (%)
)	53	98.1%
]	1	1.9%

Other Punctuation

Value	Count	Frequency (%)
.	15	88.2%
,	2	11.8%

Space Separator

Value	Count	Frequency (%)
	6387	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	90989	93.2%
Common	6600	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14844	16.3%
i	10899	12.0%
o	5954	6.5%
e	5847	6.4%
l	5755	6.3%
r	5442	6.0%
n	4824	5.3%
d	3581	3.9%
s	3297	3.6%
m	2881	3.2%
Other values (50)	27665	30.4%

Common

Value	Count	Frequency (%)
	6387	96.8%
(	53	0.8%
)	53	0.8%
0	16	0.2%
.	15	0.2%
3	13	0.2%
1	12	0.2%
4	10	0.2%
7	8	0.1%
2	8	0.1%
Other values (8)	25	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	94815	97.2%
None	2774	2.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14844	15.7%
i	10899	11.5%
	6387	6.7%
o	5954	6.3%
e	5847	6.2%
l	5755	6.1%
r	5442	5.7%
n	4824	5.1%
d	3581	3.8%
s	3297	3.5%
Other values (56)	27985	29.5%

None

Value	Count	Frequency (%)
ó	601	21.7%
ç	514	18.5%
ã	465	16.8%
í	375	13.5%
é	325	11.7%
ú	229	8.3%
á	97	3.5%
õ	82	3.0%
Á	56	2.0%
ô	27	1.0%
Other values (2)	3	0.1%

point_location
Text

Distinct	6148
Distinct (%)	73.5%
Missing	0
Missing (%)	0.0%
Memory size	65.5 KiB

Length

Max length	36
Median length	36
Mean length	35.686701
Min length	31

Characters and Unicode

Total characters	298662
Distinct characters	17
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4704 ?
Unique (%)	56.2%

Sample

1st row	23 37m 28.7148s S, 46 44m 19.55s W
2nd row	23 33m 11.0052s S, 46 38m 55.3855s W
3rd row	23 36m 24.8717s S, 46 38m 4.00848s W
4th row	23 32m 23.086s S, 46 34m 3.2016s W
5th row	23 35m 31.1615s S, 46 37m 31.8576s W

Value	Count	Frequency (%)
23	8369	12.5%
46	8369	12.5%
w	8369	12.5%
s	8369	12.5%
39m	1803	2.7%
40m	1791	2.7%
36m	1677	2.5%
38m	1617	2.4%
37m	1603	2.4%
34m	1441	2.2%
Other values (12123)	23544	35.2%

Most occurring characters

Value	Count	Frequency (%)
	58583	19.6%
3	33529	11.2%
4	26053	8.7%
2	22413	7.5%
6	19316	6.5%
s	16738	5.6%
m	16738	5.6%
.	16735	5.6%
1	12564	4.2%
5	11719	3.9%
Other values (7)	64274	21.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	164761	55.2%
Space Separator	58583	19.6%
Lowercase Letter	33476	11.2%
Other Punctuation	25104	8.4%
Uppercase Letter	16738	5.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	33529	20.4%
4	26053	15.8%
2	22413	13.6%
6	19316	11.7%
1	12564	7.6%
5	11719	7.1%
8	10823	6.6%
9	9956	6.0%
7	9745	5.9%
0	8643	5.2%

Lowercase Letter

Value	Count	Frequency (%)
s	16738	50.0%
m	16738	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	16735	66.7%
,	8369	33.3%

Uppercase Letter

Value	Count	Frequency (%)
S	8369	50.0%
W	8369	50.0%

Space Separator

Value	Count	Frequency (%)
	58583	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	248448	83.2%
Latin	50214	16.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
	58583	23.6%
3	33529	13.5%
4	26053	10.5%
2	22413	9.0%
6	19316	7.8%
.	16735	6.7%
1	12564	5.1%
5	11719	4.7%
8	10823	4.4%
9	9956	4.0%
Other values (3)	26757	10.8%

Latin

Value	Count	Frequency (%)
s	16738	33.3%
m	16738	33.3%
S	8369	16.7%
W	8369	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	298662	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	58583	19.6%
3	33529	11.2%
4	26053	8.7%
2	22413	7.5%
6	19316	6.5%
s	16738	5.6%
m	16738	5.6%
.	16735	5.6%
1	12564	4.2%
5	11719	3.9%
Other values (7)	64274	21.5%

Auto

Heatmap
Table

	rooms	garages	useful_area	latitude	longitude	value	time_on_market	Unnamed: 0	interior_quality	sold
rooms	1.000	0.664	0.765	-0.033	-0.114	0.669	0.082	-0.007	0.000	0.109
garages	0.664	1.000	0.712	-0.124	-0.183	0.676	0.093	-0.056	0.000	0.124
useful_area	0.765	0.712	1.000	0.004	-0.153	0.917	0.119	-0.013	0.000	0.154
latitude	-0.033	-0.124	0.004	1.000	0.054	0.036	0.020	0.034	0.000	0.068
longitude	-0.114	-0.183	-0.153	0.054	1.000	-0.174	-0.034	0.053	0.000	0.100
value	0.669	0.676	0.917	0.036	-0.174	1.000	0.224	-0.027	0.020	0.268
time_on_market	0.082	0.093	0.119	0.020	-0.034	0.224	1.000	-0.042	0.049	0.371
Unnamed: 0	-0.007	-0.056	-0.013	0.034	0.053	-0.027	-0.042	1.000	0.000	0.039
interior_quality	0.000	0.000	0.000	0.000	0.000	0.020	0.049	0.000	1.000	0.052
sold	0.109	0.124	0.154	0.068	0.100	0.268	0.371	0.039	0.052	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	rooms	garages	useful_area	latitude	longitude	value	interior_quality	time_on_market	sold	Unnamed: 0	endereço	bairro	point_location
0	3.0	2.0	77	-23.624629	-46.738757	686126	2	75.838273	0	0	R. José de Oliveira Coelho, 200 - Vila Andrade, São Paulo - SP, 05727-240, Brazil	Vila Andrade	23 37m 28.7148s S, 46 44m 19.55s W
1	1.0	1.0	35	-23.553170	-46.648687	675152	3	215.490618	0	1	R. Araquã, 70 - Bela Vista, São Paulo - SP, 01306-020, Brazil	Bela Vista	23 33m 11.0052s S, 46 38m 55.3855s W
2	3.0	2.0	97	-23.607094	-46.634414	871258	2	92.048200	0	2	Rua Correia de Lemos, 327 - Vila da Saúde, São Paulo - SP, 04140-000, Brazil	Vila da Saúde	23 36m 24.8717s S, 46 38m 4.00848s W
3	3.0	3.0	102	-23.539732	-46.567559	648740	3	32.000000	1	3	R. Itapura, 129 - Vila Gomes Cardim, São Paulo - SP, 03310-000, Brazil	Vila Gomes Cardim	23 32m 23.086s S, 46 34m 3.2016s W
4	2.0	1.0	78	-23.591993	-46.625481	968643	2	319.570866	0	4	R. Garapeba, 255 - Jardim Vila Mariana, São Paulo - SP, 04116-210, Brazil	Jardim Vila Mariana	23 35m 31.1615s S, 46 37m 31.8576s W
5	3.0	3.0	210	-23.616330	-46.682541	2175420	2	93.355255	0	5	Condomínio Edificio Harmony Plan - R. Flórida, 169 - Vila Cordeiro, São Paulo - SP, 04565-000, Brazil	Vila Cordeiro	23 36m 58.7837s S, 46 40m 57.1447s W
6	2.0	1.0	70	-23.546449	-46.650388	592282	2	20.000000	1	6	R. Dr. Vila Nova, 300 - Vila Buarque, São Paulo - SP, 01222-020, Brazil	Vila Buarque	23 32m 47.1815s S, 46 39m 1.55772s W
7	3.0	2.0	94	-23.611557	-46.635199	972772	1	1.151730	0	7	Praça da Árvore, 300 - Bosque da Saúde, São Paulo - SP, 04142-000, Brazil	Bosque da Saúde	23 36m 41.94s S, 46 38m 6.93348s W
8	4.0	4.0	220	-23.625767	-46.731048	1284100	3	5.000000	1	8	R. Frederico Guarinon, 125 - Jardim Ampliacao, São Paulo - SP, 05713-460, Brazil	Jardim Ampliacao	23 37m 32.7594s S, 46 43m 51.7721s W
9	2.0	1.0	110	-23.533349	-46.704305	844643	3	9.000000	1	9	Rua Tonelero, 593 - Vila Ipojuca, São Paulo - SP, 05056-000, Brazil	Vila Ipojuca	23 32m 0.02112s S, 46 42m 15.5207s W

	rooms	garages	useful_area	latitude	longitude	value	interior_quality	time_on_market	sold	Unnamed: 0	endereço	bairro	point_location
8359	3.0	2.0	83	-23.590720	-46.718816	754080	2	13.201734	0	6286	R. Dom Armando Lombardi, 643 - Vila Progredior, São Paulo - SP, 05616-011, Brazil	Vila Progredior	23 35m 26.7781s S, 46 43m 7.72068s W
8360	3.0	2.0	126	-23.636496	-46.645191	665930	3	35.000000	1	1309	R. Freire Farto, 58 - Jabaquara, São Paulo - SP, 04343-120, Brazil	Jabaquara	23 38m 11.7881s S, 46 38m 43.0318s W
8361	1.0	1.0	50	-23.628118	-46.635012	445519	3	190.889398	0	6287	Unidade - R. Maj. Freire, 594 - Vila Monte Alegre, São Paulo - SP, 04303, Brazil	Vila Monte Alegre	23 37m 41.2709s S, 46 38m 6.30672s W
8362	1.0	1.0	43	-23.540164	-46.650545	507799	2	8.000000	1	4983	Rua Dona Veridiana, 64a - Higienópolis, São Paulo - SP, 01238-010, Brazil	Higienópolis	23 32m 24.9392s S, 46 39m 1.96092s W
8363	4.0	2.0	160	-23.628829	-46.635718	1425660	2	288.390865	0	6288	R. dos Democratas, 691 - Vila Monte Alegre, São Paulo - SP, 04305-000, Brazil	Vila Monte Alegre	23 37m 43.1263s S, 46 38m 8.5668s W
8364	2.0	1.0	78	-23.584908	-46.676179	998382	1	328.751289	0	6289	R. Joaquim Floriano, 640 - Itaim Bibi, São Paulo - SP, 45340-002, Brazil	Itaim Bibi	23 35m 5.66916s S, 46 40m 34.3265s W
8365	2.0	1.0	66	-23.620348	-46.640590	534478	2	331.336993	0	6290	Condomínio Edifício Uvaias - R. das Uvaias, 145 - Vila da Saúde, São Paulo - SP, 04055-110, Brazil	Vila da Saúde	23 37m 13.2514s S, 46 38m 26.1233s W
8366	4.0	4.0	263	-23.499382	-46.641873	2214300	1	66.532605	0	5411	R. Benta Pereira, 315 - Santa Teresinha, São Paulo - SP, 02451-000, Brazil	Santa Teresinha	23 29m 58.1248s S, 46 38m 31.0474s W
8367	1.0	1.0	43	-23.624537	-46.669673	419539	2	276.046916	0	6291	Condomínio Edifício Mila - R. Vicente Leporace, 1320 - Campo Belo, São Paulo - SP, 04619-033, Brazil	Campo Belo	23 37m 28.3537s S, 46 40m 10.7605s W
8368	1.0	1.0	40	-23.619506	-46.640585	252295	1	100.000000	1	4467	Condomínio Edifício Claudia - R. das Uvaias, 52 - Mirandópolis, São Paulo - SP, 04055-110, Brazil	Mirandópolis	23 37m 10.2198s S, 46 38m 26.1028s W

Most frequently occurring

	rooms	garages	useful_area	latitude	longitude	value	interior_quality	time_on_market	sold	Unnamed: 0	endereço	bairro	point_location	# duplicates
0	2.0	1.0	57	-23.574803	-46.614062	297708	1	12.0	1	771	R. Dom Mateus, 44 - 10º andar - Vila Monumento, São Paulo - SP, 01548-030, Brazil	Vila Monumento	23 34m 29.3628s S, 46 36m 50.598s W	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Space Separator

Other Letter

Format

Other Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Open Punctuation

Close Punctuation

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Other Punctuation

Uppercase Letter

Space Separator

Most occurring scripts